Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	485587
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	524
Duplicate rows (%)	0.1%
Total size in memory	63.0 MiB
Average record size in memory	136.0 B

Variable types

NUM	9
CAT	8

Warnings

Dataset has 524 (0.1%) duplicate rows	Duplicates
`Hotel_Address` has a high cardinality: 1407 distinct values	High cardinality
`Review_Date` has a high cardinality: 731 distinct values	High cardinality
`Hotel_Name` has a high cardinality: 1406 distinct values	High cardinality
`Reviewer_Nationality` has a high cardinality: 226 distinct values	High cardinality
`Negative_Review` has a high cardinality: 310185 distinct values	High cardinality
`Positive_Review` has a high cardinality: 388928 distinct values	High cardinality
`Tags` has a high cardinality: 52838 distinct values	High cardinality
`days_since_review` has a high cardinality: 731 distinct values	High cardinality
`Review_Total_Negative_Word_Counts` has 120882 (24.9%) zeros	Zeros
`Review_Total_Positive_Word_Counts` has 33674 (6.9%) zeros	Zeros

Reproduction

Analysis started	2020-12-06 07:54:28.386638
Analysis finished	2020-12-06 07:55:43.989209
Duration	1 minute and 15.6 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

Hotel_Address
Categorical

HIGH CARDINALITY

Distinct	1407
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

163 Marsh Wall Docklands Tower Hamlets London E14 9SJ United Kingdom	4789
372 Strand Westminster Borough London WC2R 0JJ United Kingdom	4256
Scarsdale Place Kensington Kensington and Chelsea London W8 5SY United Kingdom	3578
7 Pepys Street City of London London EC3N 4AF United Kingdom	3212
1 Inverness Terrace Westminster Borough London W2 3JP United Kingdom	2958
Other values (1402)	466794

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
163 Marsh Wall Docklands Tower Hamlets London E14 9SJ United Kingdom	4789	1.0%
372 Strand Westminster Borough London WC2R 0JJ United Kingdom	4256	0.9%
Scarsdale Place Kensington Kensington and Chelsea London W8 5SY United Kingdom	3578	0.7%
7 Pepys Street City of London London EC3N 4AF United Kingdom	3212	0.7%
1 Inverness Terrace Westminster Borough London W2 3JP United Kingdom	2958	0.6%
225 Edgware Road Westminster Borough London W2 1JU United Kingdom	2628	0.5%
4 18 Harrington Gardens Kensington and Chelsea London SW7 4LH United Kingdom	2565	0.5%
1 Waterview Drive Greenwich London SE10 0TW United Kingdom	2551	0.5%
27 Devonshire Terrace Westminster Borough London W2 3DP United Kingdom	2288	0.5%
Lakeside Way Brent London HA9 0BU United Kingdom	2227	0.5%
Other values (1397)	454535	93.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	96
Median length	60
Mean length	60.22076374
Min length	34

Additional_Number_of_Scoring
Real number (ℝ_≥0)

Distinct	471
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	483.0977065
Minimum	1
Maximum	2682
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	1
5-th percentile	58
Q1	169
median	341
Q3	639
95-th percentile	1427
Maximum	2682
Range	2681
Interquartile range (IQR)	470

Descriptive statistics

Standard deviation	468.5752141
Coefficient of variation (CV)	0.9699388091
Kurtosis	5.699915054
Mean	483.0977065
Median Absolute Deviation (MAD)	200
Skewness	2.143064613
Sum	234585966
Variance	219562.7313
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2682	4789	1.0%
2288	4256	0.9%
1831	3578	0.7%
1936	3212	0.7%
256	3079	0.6%
1274	2958	0.6%
832	2934	0.6%
1485	2628	0.5%
704	2600	0.5%
1444	2565	0.5%
Other values (461)	452988	93.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	13	< 0.1%
4	12	< 0.1%
5	39	< 0.1%
6	118	< 0.1%
7	56	< 0.1%

Value	Count	Frequency (%)
2682	4789	1.0%
2288	4256	0.9%
1936	3212	0.7%
1831	3578	0.7%
1485	2628	0.5%

Review_Date
Categorical

HIGH CARDINALITY

Distinct	731
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

8/2/2017	2452
9/15/2016	2170
4/5/2017	2157
2/16/2016	1851
8/30/2016	1850
Other values (726)	475107

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
8/2/2017	2452	0.5%
9/15/2016	2170	0.4%
4/5/2017	2157	0.4%
2/16/2016	1851	0.4%
8/30/2016	1850	0.4%
7/5/2016	1799	0.4%
5/31/2016	1767	0.4%
7/12/2016	1720	0.4%
12/5/2016	1691	0.3%
8/2/2016	1681	0.3%
Other values (721)	466449	96.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	10
Median length	9
Mean length	8.931740347
Min length	8

Average_Score
Real number (ℝ_≥0)

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.401729659
Minimum	6.4
Maximum	9.8
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	6.4
5-th percentile	7.4
Q1	8.1
median	8.4
Q3	8.8
95-th percentile	9.2
Maximum	9.8
Range	3.4
Interquartile range (IQR)	0.7

Descriptive statistics

Standard deviation	0.5520084327
Coefficient of variation (CV)	0.06570176084
Kurtosis	0.2718736294
Mean	8.401729659
Median Absolute Deviation (MAD)	0.4
Skewness	-0.5278649874
Sum	4079770.7
Variance	0.3047133098
Monotocity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
8.4	38438	7.9%
8.5	36914	7.6%
8.6	35370	7.3%
8.1	33991	7.0%
8.2	33869	7.0%
8.7	31916	6.6%
8.8	29642	6.1%
8.3	29546	6.1%
8.9	27637	5.7%
9.1	21123	4.3%
Other values (23)	167141	34.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.4	1163	0.2%
6.6	400	0.1%
6.7	965	0.2%
6.8	1335	0.3%
6.9	1737	0.4%

Value	Count	Frequency (%)
9.8	28	< 0.1%
9.6	915	0.2%
9.5	1207	0.2%
9.4	9126	1.9%
9.3	12416	2.6%

Hotel_Name
Categorical

HIGH CARDINALITY

Distinct	1406
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

Britannia International Hotel Canary Wharf	4789
Strand Palace Hotel	4256
Copthorne Tara Hotel London Kensington	3578
DoubleTree by Hilton Hotel London Tower of London	3212
Grand Royale London Hyde Park	2958
Other values (1401)	466794

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Britannia International Hotel Canary Wharf	4789	1.0%
Strand Palace Hotel	4256	0.9%
Copthorne Tara Hotel London Kensington	3578	0.7%
DoubleTree by Hilton Hotel London Tower of London	3212	0.7%
Grand Royale London Hyde Park	2958	0.6%
Hilton London Metropole	2628	0.5%
Millennium Gloucester Hotel London	2565	0.5%
Intercontinental London The O2	2551	0.5%
Park Grand Paddington Court	2288	0.5%
Hilton London Wembley	2227	0.5%
Other values (1396)	454535	93.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	60
Median length	24
Mean length	25.28946409
Min length	2

Reviewer_Nationality
Categorical

HIGH CARDINALITY

Distinct	226
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

United Kingdom	234554
United States of America	33517
Australia	20438
Ireland	13967
United Arab Emirates	9617
Other values (221)	173494

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
United Kingdom	234554	48.3%
United States of America	33517	6.9%
Australia	20438	4.2%
Ireland	13967	2.9%
United Arab Emirates	9617	2.0%
Saudi Arabia	8459	1.7%
Netherlands	8173	1.7%
Switzerland	7888	1.6%
Canada	7450	1.5%
Germany	7235	1.5%
Other values (216)	134289	27.7%

Frequencies of value counts

Unique

Unique	11 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	38
Median length	16
Mean length	14.09081998
Min length	1

Negative_Review
Categorical

HIGH CARDINALITY

Distinct	310185
Distinct (%)	63.9%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

No Negative	120882
Nothing	13645
Nothing	4005
nothing	2098
N A	978
Other values (310180)	343979

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
No Negative	120882	24.9%
Nothing	13645	2.8%
Nothing	4005	0.8%
nothing	2098	0.4%
N A	978	0.2%
None	930	0.2%
	772	0.2%
N a	488	0.1%
Breakfast	366	0.1%
Small room	354	0.1%
Other values (310175)	341069	70.2%

Frequencies of value counts

Unique

Unique	304056 ?
Unique (%)	62.6%

Histogram of lengths of the category

Length

Max length	1966
Median length	41
Mean length	93.31664357
Min length	1

Review_Total_Negative_Word_Counts
Real number (ℝ_≥0)

ZEROS

Distinct	401
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	18.44299374
Minimum	0
Maximum	408
Zeros	120882
Zeros (%)	24.9%
Memory size	3.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	9
Q3	23
95-th percentile	68
Maximum	408
Range	408
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	29.57196064
Coefficient of variation (CV)	1.603425185
Kurtosis	31.62702363
Mean	18.44299374
Median Absolute Deviation (MAD)	9
Skewness	4.419364711
Sum	8955678
Variance	874.5008561
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	120882	24.9%
2	23318	4.8%
3	17173	3.5%
6	16766	3.5%
5	15811	3.3%
7	15184	3.1%
4	14237	2.9%
8	13911	2.9%
9	12868	2.6%
10	11683	2.4%
Other values (391)	223754	46.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	120882	24.9%
2	23318	4.8%
3	17173	3.5%
4	14237	2.9%
5	15811	3.3%

Value	Count	Frequency (%)
408	1	< 0.1%
403	2	< 0.1%
402	1	< 0.1%
401	1	< 0.1%
399	2	< 0.1%

Total_Number_of_Reviews
Real number (ℝ_≥0)

Distinct	1087
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2576.012566
Minimum	43
Maximum	9568
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	43
5-th percentile	423
Q1	1140
median	2058
Q3	3550
95-th percentile	6977
Maximum	9568
Range	9525
Interquartile range (IQR)	2410

Descriptive statistics

Standard deviation	1950.174415
Coefficient of variation (CV)	0.7570515922
Kurtosis	1.793005789
Mean	2576.012566
Median Absolute Deviation (MAD)	1059
Skewness	1.372746894
Sum	1250878214
Variance	3803180.248
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9086	4789	1.0%
9568	4256	0.9%
7105	3578	0.7%
7491	3212	0.7%
6539	2958	0.6%
6977	2628	0.5%
5726	2565	0.5%
4204	2551	0.5%
6608	2288	0.5%
4305	2227	0.5%
Other values (1077)	454535	93.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
43	12	< 0.1%
45	12	< 0.1%
49	40	< 0.1%
51	13	< 0.1%
54	13	< 0.1%

Value	Count	Frequency (%)
9568	4256	0.9%
9086	4789	1.0%
8177	1809	0.4%
7586	1686	0.3%
7491	3212	0.7%

Positive_Review
Categorical

HIGH CARDINALITY

Distinct	388928
Distinct (%)	80.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

No Positive	33674
Location	8747
Everything	2153
location	1590
Nothing	1168
Other values (388923)	438255

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
No Positive	33674	6.9%
Location	8747	1.8%
Everything	2153	0.4%
location	1590	0.3%
Nothing	1168	0.2%
The location	1086	0.2%
Great location	992	0.2%
Good location	889	0.2%
Location	873	0.2%
Everything	574	0.1%
Other values (388918)	433841	89.3%

Frequencies of value counts

Unique

Unique	379997 ?
Unique (%)	78.3%

Histogram of lengths of the category

Length

Max length	1960
Median length	59
Mean length	94.66395929
Min length	1

Review_Total_Positive_Word_Counts
Real number (ℝ_≥0)

ZEROS

Distinct	364
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	17.78124414
Minimum	0
Maximum	395
Zeros	33674
Zeros (%)	6.9%
Memory size	3.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	11
Q3	22
95-th percentile	56
Maximum	395
Range	395
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	21.80042826
Coefficient of variation (CV)	1.226035034
Kurtosis	32.90596346
Mean	17.78124414
Median Absolute Deviation (MAD)	7
Skewness	4.189315203
Sum	8634341
Variance	475.2586723
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33674	6.9%
6	25348	5.2%
5	25252	5.2%
4	23202	4.8%
7	23117	4.8%
8	21876	4.5%
3	21270	4.4%
9	19904	4.1%
2	19725	4.1%
10	18548	3.8%
Other values (354)	253671	52.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33674	6.9%
2	19725	4.1%
3	21270	4.4%
4	23202	4.8%
5	25252	5.2%

Value	Count	Frequency (%)
395	1	< 0.1%
386	1	< 0.1%
384	2	< 0.1%
383	2	< 0.1%
382	1	< 0.1%

Total_Number_of_Reviews_Reviewer_Has_Given
Real number (ℝ_≥0)

Distinct	195
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.102294748
Minimum	1
Maximum	355
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	8
95-th percentile	26
Maximum	355
Range	354
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	10.98446699
Coefficient of variation (CV)	1.546608157
Kurtosis	53.2773348
Mean	7.102294748
Median Absolute Deviation (MAD)	2
Skewness	5.155118644
Sum	3448782
Variance	120.6585151
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	146764	30.2%
2	63498	13.1%
3	44323	9.1%
4	32911	6.8%
5	25945	5.3%
6	21260	4.4%
7	17463	3.6%
8	15102	3.1%
9	12667	2.6%
10	10933	2.3%
Other values (185)	94721	19.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	146764	30.2%
2	63498	13.1%
3	44323	9.1%
4	32911	6.8%
5	25945	5.3%

Value	Count	Frequency (%)
355	1	< 0.1%
330	1	< 0.1%
315	4	< 0.1%
297	2	< 0.1%
281	2	< 0.1%

Reviewer_Score
Real number (ℝ_≥0)

Distinct	37
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.402592532
Minimum	2.5
Maximum	10
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	2.5
5-th percentile	5
Q1	7.5
median	8.8
Q3	9.6
95-th percentile	10
Maximum	10
Range	7.5
Interquartile range (IQR)	2.1

Descriptive statistics

Standard deviation	1.636499496
Coefficient of variation (CV)	0.1947612585
Kurtosis	0.9824423663
Mean	8.402592532
Median Absolute Deviation (MAD)	1.2
Skewness	-1.198372938
Sum	4080189.7
Variance	2.678130602
Monotocity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
10	110142	22.7%
9.6	67266	13.9%
9.2	55143	11.4%
8.8	43455	8.9%
8.3	38543	7.9%
7.5	32727	6.7%
7.9	30997	6.4%
7.1	23278	4.8%
6.7	17575	3.6%
6.3	13965	2.9%
Other values (27)	52496	10.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.5	2038	0.4%
2.9	1480	0.3%
3	34	< 0.1%
3.1	8	< 0.1%
3.3	2613	0.5%

Value	Count	Frequency (%)
10	110142	22.7%
9.6	67266	13.9%
9.5	682	0.1%
9.4	57	< 0.1%
9.2	55143	11.4%

Tags
Categorical

HIGH CARDINALITY

Distinct	52838
Distinct (%)	10.9%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	4691
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	4660
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	4206
[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	3959
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	2928
Other values (52833)	465143

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	4691	1.0%
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	4660	1.0%
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	4206	0.9%
[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	3959	0.8%
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	2928	0.6%
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	2917	0.6%
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	2752	0.6%
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ']	2572	0.5%
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 1 night ']	2454	0.5%
[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	2287	0.5%
Other values (52828)	452161	93.1%

Frequencies of value counts

Unique

Unique	28587 ?
Unique (%)	5.9%

Histogram of lengths of the category

Length

Max length	213
Median length	108
Mean length	102.4322665
Min length	11

days_since_review
Categorical

HIGH CARDINALITY

Distinct	731
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

1 days	2452
322 day	2170
120 day	2157
534 day	1851
338 day	1850
Other values (726)	475107

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
1 days	2452	0.5%
322 day	2170	0.4%
120 day	2157	0.4%
534 day	1851	0.4%
338 day	1850	0.4%
394 day	1799	0.4%
429 day	1767	0.4%
387 day	1720	0.4%
241 day	1691	0.3%
366 day	1681	0.3%
Other values (721)	466449	96.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	7
Median length	7
Mean length	6.984140844
Min length	6

lat
Real number (ℝ_≥0)

Distinct	1404
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	49.47479932
Minimum	41.3283758
Maximum	52.4001813
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	41.3283758
5-th percentile	41.386136
Q1	48.8346811
median	51.5013149
Q3	51.5166755
95-th percentile	52.369391
Maximum	52.4001813
Range	11.0718055
Interquartile range (IQR)	2.6819944

Descriptive statistics

Standard deviation	3.484356032
Coefficient of variation (CV)	0.07042688561
Kurtosis	0.7584232953
Mean	49.47479932
Median Absolute Deviation (MAD)	0.0445327
Skewness	-1.452080311
Sum	24024319.38
Variance	12.14073696
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
51.5019097	4789	1.0%
51.5110993	4256	0.9%
51.499046	3578	0.7%
51.5108412	3212	0.7%
51.5109945	2958	0.6%
51.5195688	2628	0.5%
51.4935083	2565	0.5%
51.5024348	2551	0.5%
51.5135555	2288	0.5%
51.5576962	2227	0.5%
Other values (1394)	454535	93.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
41.3283758	572	0.1%
41.368437	575	0.1%
41.3703041	229	< 0.1%
41.371308	1082	0.2%
41.3725246	120	< 0.1%

Value	Count	Frequency (%)
52.4001813	312	0.1%
52.3924898	467	0.1%
52.3923684	143	< 0.1%
52.3872884	856	0.2%
52.3856494	1071	0.2%

lng
Real number (ℝ)

Distinct	1404
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.630325181
Minimum	-0.3192925
Maximum	16.4217627
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	-0.3192925
5-th percentile	-0.1949706
Q1	-0.1444623
median	-0.0071375
Q3	2.3556545
95-th percentile	16.3546297
Maximum	16.4217627
Range	16.7410552
Interquartile range (IQR)	2.5001168

Descriptive statistics

Standard deviation	4.43069956
Coefficient of variation (CV)	1.684468366
Kurtosis	3.513074748
Mean	2.630325181
Median Absolute Deviation (MAD)	0.2217223
Skewness	2.056953327
Sum	1277251.714
Variance	19.6310986
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.0232208	4789	1.0%
-0.1208673	4256	0.9%
-0.1917073	3578	0.7%
-0.0780581	3212	0.7%
-0.1863417	2958	0.6%
-0.170521	2628	0.5%
-0.1834346	2565	0.5%
-0.0002497	2551	0.5%
-0.180002	2288	0.5%
-0.2835263	2227	0.5%
Other values (1394)	454535	93.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.3192925	391	0.1%
-0.306071	128	< 0.1%
-0.2915052	385	0.1%
-0.290706	680	0.1%
-0.2864945	1212	0.2%

Value	Count	Frequency (%)
16.4217627	426	0.1%
16.4200957	431	0.1%
16.4133973	191	< 0.1%
16.4129493	501	0.1%
16.4116997	92	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	Hotel_Address	Additional_Number_of_Scoring	Review_Date	Average_Score	Hotel_Name	Reviewer_Nationality	Negative_Review	Review_Total_Negative_Word_Counts	Total_Number_of_Reviews	Positive_Review	Review_Total_Positive_Word_Counts	Total_Number_of_Reviews_Reviewer_Has_Given	Reviewer_Score	Tags	days_since_review	lat	lng
0	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	8/3/2017	7.7	Hotel Arena	Russia	I am so angry that i made this post available via all possible sites i use when planing my trips so no one will make the mistake of booking this place I made my booking via booking com We stayed for 6 nights in this hotel from 11 to 17 July Upon arrival we were placed in a small room on the 2nd floor of the hotel It turned out that this was not the room we booked I had specially reserved the 2 level duplex room so that we would have a big windows and high ceilings The room itself was ok if you don t mind the broken window that can not be closed hello rain and a mini fridge that contained some sort of a bio weapon at least i guessed so by the smell of it I intimately asked to change the room and after explaining 2 times that i booked a duplex btw it costs the same as a simple double but got way more volume due to the high ceiling was offered a room but only the next day SO i had to check out the next day before 11 o clock in order to get the room i waned to Not the best way to begin your holiday So we had to wait till 13 00 in order to check in my new room what a wonderful waist of my time The room 023 i got was just as i wanted to peaceful internal garden view big window We were tired from waiting the room so we placed our belongings and rushed to the city In the evening it turned out that there was a constant noise in the room i guess it was made by vibrating vent tubes or something it was constant and annoying as hell AND it did not stop even at 2 am making it hard to fall asleep for me and my wife I have an audio recording that i can not attach here but if you want i can send it via e mail The next day the technician came but was not able to determine the cause of the disturbing sound so i was offered to change the room once again the hotel was fully booked and they had only 1 room left the one that was smaller but seems newer	397	1403	Only the park outside of the hotel was beautiful	11.0	7.0	2.9	[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 6 nights ']	0 days	52.360576	4.915968
1	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	8/3/2017	7.7	Hotel Arena	Ireland	No Negative	0	1403	No real complaints the hotel was great great location surroundings rooms amenities and service Two recommendations however firstly the staff upon check in are very confusing regarding deposit payments and the staff offer you upon checkout to refund your original payment and you can make a new one Bit confusing Secondly the on site restaurant is a bit lacking very well thought out and excellent quality food for anyone of a vegetarian or vegan background but even a wrap or toasted sandwich option would be great Aside from those minor minor things fantastic spot and will be back when i return to Amsterdam	105.0	7.0	7.5	[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 4 nights ']	0 days	52.360576	4.915968
2	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/31/2017	7.7	Hotel Arena	Australia	Rooms are nice but for elderly a bit difficult as most rooms are two story with narrow steps So ask for single level Inside the rooms are very very basic just tea coffee and boiler and no bar empty fridge	42	1403	Location was good and staff were ok It is cute hotel the breakfast range is nice Will go back	21.0	9.0	7.1	[' Leisure trip ', ' Family with young children ', ' Duplex Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']	3 days	52.360576	4.915968
3	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/31/2017	7.7	Hotel Arena	United Kingdom	My room was dirty and I was afraid to walk barefoot on the floor which looked as if it was not cleaned in weeks White furniture which looked nice in pictures was dirty too and the door looked like it was attacked by an angry dog My shower drain was clogged and the staff did not respond to my request to clean it On a day with heavy rainfall a pretty common occurrence in Amsterdam the roof in my room was leaking luckily not on the bed you could also see signs of earlier water damage I also saw insects running on the floor Overall the second floor of the property looked dirty and badly kept On top of all of this a repairman who came to fix something in a room next door at midnight was very noisy as were many of the guests I understand the challenges of running a hotel in an old building but this negligence is inconsistent with prices demanded by the hotel On the last night after I complained about water damage the night shift manager offered to move me to a different room but that offer came pretty late around midnight when I was already in bed and ready to sleep	210	1403	Great location in nice surroundings the bar and restaurant are nice and have a lovely outdoor area The building also has quite some character	26.0	1.0	3.8	[' Leisure trip ', ' Solo traveler ', ' Duplex Double Room ', ' Stayed 3 nights ']	3 days	52.360576	4.915968
4	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/24/2017	7.7	Hotel Arena	New Zealand	You When I booked with your company on line you showed me pictures of a room I thought I was getting and paying for and then when we arrived that s room was booked and the staff told me we could only book the villa suite theough them directly Which was completely false advertising After being there we realised that you have grouped lots of rooms on the photos together leaving me the consumer confused and extreamly disgruntled especially as its my my wife s 40th birthday present Please make your website more clear through pricing and photos as again I didn t really know what I was paying for and how much it had wnded up being Your photos told me I was getting something I wasn t Not happy and won t be using you again	140	1403	Amazing location and building Romantic setting	8.0	3.0	6.7	[' Leisure trip ', ' Couple ', ' Suite ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	10 days	52.360576	4.915968
5	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/24/2017	7.7	Hotel Arena	Poland	Backyard of the hotel is total mess shouldn t happen in hotel with 4 stars	17	1403	Good restaurant with modern design great chill out place Great park nearby the hotel and awesome main stairs	20.0	1.0	6.7	[' Leisure trip ', ' Group ', ' Duplex Double Room ', ' Stayed 1 night ']	10 days	52.360576	4.915968
6	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/17/2017	7.7	Hotel Arena	United Kingdom	Cleaner did not change our sheet and duvet everyday but just made bed They also didn t clean the floor and changed the body gel when we run out of it	33	1403	The room is spacious and bright The hotel is located in a quiet and beautiful park	18.0	6.0	4.6	[' Leisure trip ', ' Group ', ' Duplex Twin Room ', ' Stayed 5 nights ', ' Submitted from a mobile device ']	17 days	52.360576	4.915968
7	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/17/2017	7.7	Hotel Arena	United Kingdom	Apart from the price for the brekfast Everything very good	11	1403	Good location Set in a lovely park friendly staff Food high quality We Oth enjoyed the breakfast	19.0	1.0	10.0	[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	17 days	52.360576	4.915968
8	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/9/2017	7.7	Hotel Arena	Belgium	Even though the pictures show very clean rooms the actual room was quit dirty and outlived Also check in is at 15 o clock but our room was not ready at that time	34	1403	No Positive	0.0	3.0	6.5	[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	25 days	52.360576	4.915968
9	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/8/2017	7.7	Hotel Arena	Norway	The aircondition makes so much noise and its hard to sleep at night	15	1403	The room was big enough and the bed is good The breakfast food and service on the hotel is good outside the hotel there is a big park which is very good for walk in the morning and evening Many people are having picnics and do some bicycling	50.0	1.0	7.9	[' Leisure trip ', ' Couple ', ' Large King Room ', ' Stayed 7 nights ']	26 days	52.360576	4.915968

Last rows

	Hotel_Address	Additional_Number_of_Scoring	Review_Date	Average_Score	Hotel_Name	Reviewer_Nationality	Negative_Review	Review_Total_Negative_Word_Counts	Total_Number_of_Reviews	Positive_Review	Review_Total_Positive_Word_Counts	Total_Number_of_Reviews_Reviewer_Has_Given	Reviewer_Score	Tags	days_since_review	lat	lng
485577	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/26/2015	9.0	Senato Hotel Milano	Lebanon	No Negative	0	1031	Everything was perfect	5.0	12.0	10.0	[' Leisure trip ', ' Couple ', ' Classic Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	616 day	45.471406	9.19653
485578	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/22/2015	9.0	Senato Hotel Milano	Bulgaria	Non	2	1031	Very modern rooms comfortable bed Perfect breacfast great location	11.0	11.0	9.6	[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	620 day	45.471406	9.19653
485579	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/21/2015	9.0	Senato Hotel Milano	United States of America	No Negative	0	1031	Very helpful people A lovely design of the rooms and public spaces	14.0	1.0	8.8	[' Business trip ', ' Group ', ' Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']	621 day	45.471406	9.19653
485580	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/19/2015	9.0	Senato Hotel Milano	United States of America	No Negative	0	1031	a little far from subway but very close to the main fashion area	15.0	7.0	9.2	[' Leisure trip ', ' Couple ', ' Double Room with Terrace ', ' Stayed 1 night ']	623 day	45.471406	9.19653
485581	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/17/2015	9.0	Senato Hotel Milano	Hong Kong	No Negative	0	1031	Easy to access all the major area Staffs are nice Room r tidy with all the essential	19.0	1.0	8.3	[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 4 nights ', ' Submitted from a mobile device ']	625 day	45.471406	9.19653
485582	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/16/2015	9.0	Senato Hotel Milano	Belgium	No Negative	0	1031	Beautiful design perfect location great breakfast And friendly staf	11.0	29.0	10.0	[' Leisure trip ', ' Family with older children ', ' Superior Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	626 day	45.471406	9.19653
485583	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/12/2015	9.0	Senato Hotel Milano	Saudi Arabia	The room was very small	7	1031	The location and cleanless	5.0	9.0	6.3	[' Leisure trip ', ' Solo traveler ', ' Single Room ', ' Stayed 1 night ']	630 day	45.471406	9.19653
485584	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/12/2015	9.0	Senato Hotel Milano	United States of America	The pendant lights at the night stand only worked one side Far walk from subway	17	1031	Nicely designed hotel Good location near the action	10.0	7.0	8.8	[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	630 day	45.471406	9.19653
485585	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/10/2015	9.0	Senato Hotel Milano	Turkey	No Negative	0	1031	Rooms Breakfast Location	4.0	3.0	10.0	[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 3 nights ']	632 day	45.471406	9.19653
485586	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/8/2015	9.0	Senato Hotel Milano	India	No Negative	0	1031	Excellent ambience created by very thoughtful interior design	10.0	4.0	9.2	[' Leisure trip ', ' Solo traveler ', ' Classic Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	634 day	45.471406	9.19653

Most frequent

	Hotel_Address	Additional_Number_of_Scoring	Review_Date	Average_Score	Hotel_Name	Reviewer_Nationality	Negative_Review	Review_Total_Negative_Word_Counts	Total_Number_of_Reviews	Positive_Review	Review_Total_Positive_Word_Counts	Total_Number_of_Reviews_Reviewer_Has_Given	Reviewer_Score	Tags	days_since_review	lat	lng	count
0	100 110 Euston Road Camden London NW1 2AJ United Kingdom	728	2/25/2017	8.9	Pullman London St Pancras	China	none	2	3168	good location and super nice staff room is big and great	13.0	39.0	9.6	[' Business trip ', ' Solo traveler ', ' Classic King Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	159 day	51.528677	-0.128349	2
1	16 22 Great Russell Street Camden London WC1B 3NN United Kingdom	300	7/27/2017	9.0	The Bloomsbury Hotel	Israel	No Negative	0	1254	The attention received by Sebastian and his team was exceptional	12.0	4.0	9.6	[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	7 days	51.517167	-0.129053	2
2	167 rue de Rome 17th arr 75017 Paris France	11	10/14/2016	6.8	Villa Eugenie	Albania	They didnt change the sheets They also had a minibar coca and nestea cannets They didnt tell us that it was with payment and we had to pay 30 euros for 5 of them What an abusive bill	40	165	The room was cozy and pretty	7.0	3.0	5.8	[' Leisure trip ', ' Couple ', ' Standard Double or Twin Room ', ' Stayed 3 nights ']	293 day	48.887128	2.314205	2
3	167 rue de Rome 17th arr 75017 Paris France	11	10/14/2016	6.8	Villa Eugenie	Iran	Evry thing was wrong Cold room Dark room No refrigetor in room No ac Evry thing was baaaaaaad Very bad	21	165	This hotel was terrible this place worst place in paris Hostel is better than this place I m sorry for myself to spend my time in this place	29.0	2.0	2.5	[' Solo traveler ', ' Single Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	293 day	48.887128	2.314205	2
4	167 rue de Rome 17th arr 75017 Paris France	11	10/14/2016	6.8	Villa Eugenie	United Kingdom	Evry thing of this place i can t name horlrel to this place was wrong and out of repair all lamp were nt work 2nights i got cold in cold room Ac not working i so sorry for my self that i had to spend my time in this ruin place 4star hotel has nt refrigerator	58	165	This hotel is worst hotel Its terrible	9.0	1.0	2.5	[' Solo traveler ', ' Single Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	293 day	48.887128	2.314205	2
5	167 rue de Rome 17th arr 75017 Paris France	11	10/18/2016	6.8	Villa Eugenie	Israel	No Negative	0	165	the room was very french and beautiful it was good location and I enjoyed to stay there	18.0	1.0	9.2	[' Leisure trip ', ' Couple ', ' Twin Room ', ' Stayed 3 nights ']	289 day	48.887128	2.314205	2
6	167 rue de Rome 17th arr 75017 Paris France	11	10/18/2016	6.8	Villa Eugenie	United Kingdom	No internet it was important for me for my business Really Small Room Very Bad Location No Shampoo and staff etc You need to call them to bring All Bad sorry	32	165	Didier was friendly and good	7.0	12.0	2.5	[' Leisure trip ', ' Couple ', ' Standard Double or Twin Room ', ' Stayed 4 nights ']	289 day	48.887128	2.314205	2
7	167 rue de Rome 17th arr 75017 Paris France	11	10/19/2016	6.8	Villa Eugenie	Switzerland	Wifi was not working	6	165	No Positive	0.0	1.0	7.9	[' Leisure trip ', ' Couple ', ' Standard Double or Twin Room ', ' Stayed 2 nights ']	288 day	48.887128	2.314205	2
8	167 rue de Rome 17th arr 75017 Paris France	11	10/2/2016	6.8	Villa Eugenie	Qatar	Staff very rude My credit card was charged Before my stay and while Checking out they charged me again when I told the receptionist about it her answer was I m not trying to steal your money madam in a ver un polite way Blaming my Bank about it Very poor selection for breakfast	56	165	Nothing	3.0	8.0	5.0	[' Leisure trip ', ' Family with young children ', ' Two Connecting Double Rooms ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	305 day	48.887128	2.314205	2
9	167 rue de Rome 17th arr 75017 Paris France	11	10/20/2016	6.8	Villa Eugenie	Lithuania	We booked hotel for 3 nights and there was no normal internet connection From all trip time we had internet only for 1 2 huors Also there is very noisy almoust impossible to sleep with open window	39	165	Good place	4.0	9.0	6.7	[' Business trip ', ' Group ', ' Superior Double Room ', ' Stayed 3 nights ']	287 day	48.887128	2.314205	2

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent